package com.example.gmranqi.dao;

import org.apache.ibatis.annotations.Mapper;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

@Mapper
public interface BigScreenDao {

    List<Map<String,Object>> query_G_ADMINISTRATION();

    List<Map<String, Object>> queryNormDepart();

    List<Map<String, Object>> queryDepartByLevel(int level);

    List<Map<String, Object>> queryDepartByPid(Long pid);

    Integer queryGasSiteCount(Map<String, Object> queryMap);

    List<Map<String, Object>> queryList_G_GAS_SITE(Map<String, Object> queryMap);

    Map<String, Object> queryGasSiteById(Long id);

    Integer queryCylindersCount(Map<String, Object> queryMap);

    List<Long> getAllIds();

    List<Long> getIdsByLevelOne(Long id);

    List<Long> getIdsByLevelTwo(Long id);

    Integer queryThirdPartySiteCount(Map<String, Object> subQueryMap);

    List<Map<String, Object>> queryList_G_THIRD_PARTY_SITE(Map<String, Object> queryMap);

    Map<String, Object> queryThirdPartySiteById(Long id);

    Integer queryTaskCount(Map<String, Object> queryMap);

    List<Map<String, Object>> queryTaskList(Map<String, Object> queryMap);

    Map<String, Object> queryTaskById(Long id);

    Integer queryTaskWithPointsCount(Map<String, Object> queryMap);

    List<Map<String, Object>> queryTaskWithPointsList(Map<String, Object> queryMap);

    List<Map<String, Object>> countTaskGroupByMonth();

    Double queryGasPipeLength(Map<String, Object> gasPipeQueryMap);

    Integer queryGasUserCount(Map<String, Object> mapQuery);

    List<Map<String, Object>> queryList_G_GAS_USER(Map<String, Object> queryMap);

    Map<String, Object> queryGasUserById(Long id);

    Integer queryCount_G_GAS_PIPE(Map<String, Object> queryMap);

    List<Map<String, Object>> queryList_G_GAS_PIPE(Map<String, Object> queryMap);

    Map<String, Object> queryTaskByINSPECTOR_ID_B(BigDecimal id);

    Map<String, Object> queryTaskByINSPECTOR_ID_L(Long id);
}
